explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qpNda

Settings
# exclusive inclusive rows x rows loops node
1. 0.109 42,166.344 ↑ 1.0 150 1

Limit (cost=0.84..648.84 rows=150 width=172) (actual time=42,166.075..42,166.344 rows=150 loops=1)

2. 880.776 42,166.235 ↑ 1,029.2 150 1

WindowAgg (cost=0.84..666,917.35 rows=154,380 width=172) (actual time=42,166.073..42,166.235 rows=150 loops=1)

3. 7,596.976 41,285.459 ↓ 1.0 187,600 1

Nested Loop Left Join (cost=0.84..663,443.80 rows=185,256 width=164) (actual time=0.037..41,285.459 rows=187,600 loops=1)

4. 18,117.683 18,117.683 ↓ 1.0 187,600 1

Index Scan Backward using bo_instance_pkey on bo_instance i (cost=0.42..185,933.18 rows=185,256 width=69) (actual time=0.008..18,117.683 rows=187,600 loops=1)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 103))
  • Rows Removed by Filter: 51873
5. 15,570.800 15,570.800 ↑ 1.0 1 187,600

Index Scan using idx_attrib_touchstone_bo_instance_id on attrib_touchstone attr (cost=0.42..2.56 rows=1 width=863) (actual time=0.082..0.083 rows=1 loops=187,600)

  • Index Cond: (i.id = bo_instance_id)
Planning time : 0.432 ms
Execution time : 42,202.885 ms