explain.depesz.com

PostgreSQL's explain analyze made readable

Result: angj

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 5,010.115 ↑ 1.0 800 1

Limit (cost=0.84..585.50 rows=800 width=292) (actual time=5,009.198..5,010.115 rows=800 loops=1)

2. 512.877 5,010.075 ↑ 1,150.8 800 1

WindowAgg (cost=0.84..672,804.14 rows=920,623 width=292) (actual time=5,009.197..5,010.075 rows=800 loops=1)

3. 3,851.978 4,497.198 ↑ 4.0 232,597 1

Nested Loop Left Join (cost=0.84..652,090.12 rows=920,623 width=284) (actual time=12.059..4,497.198 rows=232,597 loops=1)

4. 180.026 180.026 ↓ 1.0 232,597 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=11.954..180.026 rows=232,597 loops=1)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 7))
  • Rows Removed by Filter: 13003
5. 465.194 465.194 ↑ 1.0 1 232,597

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=232,597)

  • Index Cond: (i.id = bo_instance_id)
Planning time : 0.443 ms
Execution time : 5,062.129 ms