explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3FFu

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 4,269.030 ↑ 1.0 800 1

Limit (cost=280,644.21..280,646.21 rows=800 width=297) (actual time=4,268.971..4,269.030 rows=800 loops=1)

2. 116.173 4,268.995 ↑ 1,150.8 800 1

Sort (cost=280,644.21..282,945.77 rows=920,623 width=297) (actual time=4,268.970..4,268.995 rows=800 loops=1)

  • Sort Key: i.tags DESC
  • Sort Method: top-N heapsort Memory: 462kB
3. 3,802.191 4,152.822 ↑ 4.0 232,597 1

Merge Right Join (cost=67,257.34..231,649.32 rows=920,623 width=297) (actual time=196.841..4,152.822 rows=232,597 loops=1)

  • Merge Cond: (attr.bo_instance_id = i.id)
4. 124.049 124.049 ↑ 4.2 232,597 1

Index Scan using idx_attrib_touchstone_bo_instance_id on attrib_touchstone attr (cost=0.42..121,671.79 rows=974,185 width=730) (actual time=0.006..124.049 rows=232,597 loops=1)

5. 125.848 226.582 ↓ 1.0 232,597 1

Sort (cost=67,256.92..67,833.62 rows=230,682 width=70) (actual time=196.819..226.582 rows=232,597 loops=1)

  • Sort Key: i.id
  • Sort Method: external merge Disk: 18736kB
6. 100.734 100.734 ↓ 1.0 232,597 1

Seq Scan on bo_instance i (cost=0.00..37,244.29 rows=230,682 width=70) (actual time=0.141..100.734 rows=232,597 loops=1)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 7))
  • Rows Removed by Filter: 13003
Planning time : 0.374 ms
Execution time : 4,271.637 ms