explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kn5O

Settings
# exclusive inclusive rows x rows loops node
1. 0.450 26,652.272 ↑ 83.1 1,253 1

Limit (cost=1,529,683,356.64..1,529,683,616.92 rows=104,110 width=92) (actual time=26,651.571..26,652.272 rows=1,253 loops=1)

2. 2.794 26,651.822 ↑ 83.1 1,253 1

Sort (cost=1,529,683,356.64..1,529,683,616.92 rows=104,110 width=92) (actual time=26,651.569..26,651.822 rows=1,253 loops=1)

  • Sort Key: ((SubPlan 1)) NULLS FIRST, a1.id
  • Sort Method: quicksort Memory: 214kB
3. 1,884.676 26,649.028 ↑ 83.1 1,253 1

Nested Loop Left Join (cost=0.57..1,529,669,339.25 rows=104,110 width=92) (actual time=0.709..26,649.028 rows=1,253 loops=1)

  • Filter: (a2.archive_on IS NULL)
  • Rows Removed by Filter: 10
4. 24,764.352 24,764.352 ↑ 108.7 1,263 1

Seq Scan on company_fields a1 (cost=0.00..1,469,688,268.42 rows=137,342 width=84) (actual time=0.532..24,764.352 rows=1,263 loops=1)

  • Filter: (((SubPlan 5) IS NOT NULL) AND ((SubPlan 4) > 10) AND ((SubPlan 2) IS NOT NULL) AND (((SubPlan 3) IS NOT NULL) IS NOT NULL) AND ((SubPlan 7) IS NOT NULL) AND ((SubPlan 6) >= 3))
  • Rows Removed by Filter: 1,259,852