explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 14sn

Settings
# exclusive inclusive rows x rows loops node
1. 0.077 61.081 ↑ 1.0 800 1

Limit (cost=0.84..2,195.50 rows=800 width=284) (actual time=24.467..61.081 rows=800 loops=1)

2. 31.727 61.004 ↑ 287.7 800 1

Nested Loop Left Join (cost=0.84..631,391.90 rows=230,156 width=284) (actual time=24.464..61.004 rows=800 loops=1)

  • Filter: ((SubPlan 1) AND (SubPlan 2))
3. 25.277 25.277 ↑ 288.4 800 1

Index Scan Backward using bo_instance_pkey on bo_instance i (cost=0.42..123,353.60 rows=230,682 width=70) (actual time=24.342..25.277 rows=800 loops=1)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 7))
  • Rows Removed by Filter: 12910
4. 1.600 1.600 ↑ 1.0 1 800

Index Scan using idx_attrib_touchstone_bo_instance_id on attrib_touchstone attr (cost=0.42..2.12 rows=1 width=730) (actual time=0.002..0.002 rows=1 loops=800)

  • Index Cond: (i.id = bo_instance_id)
5.          

SubPlan (forNested Loop Left Join)

6. 1.600 1.600 ↑ 100.0 1 800

Function Scan on unnest elem (cost=0.00..1.25 rows=100 width=0) (actual time=0.002..0.002 rows=1 loops=800)

  • Filter: ((elem)::text ~~* 'S%'::text)
7. 0.800 0.800 ↑ 100.0 1 800

Function Scan on unnest elem_1 (cost=0.00..1.25 rows=100 width=0) (actual time=0.001..0.001 rows=1 loops=800)

  • Filter: ((elem)::text ~~* 'R%'::text)
Planning time : 0.721 ms
Execution time : 61.233 ms