explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F5Wt

Settings
# exclusive inclusive rows x rows loops node
1. 663.651 17,845.706 ↑ 62.6 2,866 1

HashAggregate (cost=315,232.890..317,028.140 rows=179,525 width=22) (actual time=17,843.523..17,845.706 rows=2,866 loops=1)

  • Group Key: oscar_oscar2kilo_oscar.oscar_whiskey, oscar_oscar2kilo_oscar.india_papa, oscar_oscar2kilo_oscar.seven
2. 3,495.468 17,182.055 ↑ 1.8 266,757 1

Hash Join (cost=209,171.400..311,532.680 rows=493,362 width=22) (actual time=9,971.182..17,182.055 rows=266,757 loops=1)

  • Hash Cond: (oscar_oscar2kilo_oscar.india_zulu = six0kilo_oscar.quebec_seven)
3. 3,715.601 3,715.601 ↑ 1.0 1,786,688 1

Seq Scan on foxtrot bravo_oscar_alpha (cost=0.000..88,451.400 rows=1,795,249 width=30) (actual time=0.012..3,715.601 rows=1,786,688 loops=1)

  • Filter: ((seven)::text = ANY ('quebec_echo'::text[]))
  • Rows Removed by Filter: 518,732
4. 138.009 9,970.986 ↑ 2.2 91,195 1

Hash (cost=206,665.050..206,665.050 rows=200,508 width=32) (actual time=9,970.986..9,970.986 rows=91,195 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 5,700kB
5. 1,182.546 9,832.977 ↑ 2.2 91,195 1

Hash Join (cost=148,510.310..206,665.050 rows=200,508 width=32) (actual time=5,914.127..9,832.977 rows=91,195 loops=1)

  • Hash Cond: (six0kilo_oscar.quebec_seven = kilo_xray1kilo_oscar.india_zulu)
6. 2,736.498 2,736.498 ↑ 1.0 709,353 1

Seq Scan on bravo_oscar_papa three_whiskey (cost=0.000..49,074.150 rows=709,399 width=8) (actual time=0.011..2,736.498 rows=709,353 loops=1)

  • Filter: ((sierra = 1) AND (zulu_xray <> november ('zulu_charlie'::integer[])))
  • Rows Removed by Filter: 20,222
7. 125.521 5,913.933 ↑ 2.2 95,067 1

Hash (cost=145,944.460..145,944.460 rows=205,268 width=24) (actual time=5,913.933..5,913.933 rows=95,067 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 5,199kB
8. 1,538.803 5,788.412 ↑ 2.2 95,067 1

Hash Join (cost=95,729.640..145,944.460 rows=205,268 width=24) (actual time=3,270.380..5,788.412 rows=95,067 loops=1)

  • Hash Cond: (kilo_xray1kilo_oscar1kilo_oscar.quebec_seven = kilo_xray1kilo_oscar.india_zulu)
9. 979.408 979.408 ↑ 1.0 729,575 1

Seq Scan on bravo_oscar_papa five (cost=0.000..44,514.090 rows=729,609 width=8) (actual time=0.002..979.408 rows=729,575 loops=1)

10. 113.022 3,270.201 ↑ 2.2 95,067 1

Hash (cost=93,151.890..93,151.890 rows=206,220 width=16) (actual time=3,270.201..3,270.201 rows=95,067 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 4,457kB
11. 1,386.542 3,157.179 ↑ 2.2 95,067 1

Merge Join (cost=70,990.140..93,151.890 rows=206,220 width=16) (actual time=1,710.773..3,157.179 rows=95,067 loops=1)

  • Merge Cond: (kilo_xray1kilo_oscar.india_zulu = three_golf3kilo_oscar.india_zulu)
  • -> Index Only Scan using pk_cl_claim_extension on cl_claim_extension claimexten1_ (cost=0.42..19486.27 rows=732,992 width=8) (actual time=0.019..642.443 rows=729,519 l
  • Heap Fetches: 5,248
12. 214.389 1,770.637 ↓ 1.7 95,067 1

Sort (cost=70,989.280..71,131.180 rows=56,761 width=8) (actual time=1,710.731..1,770.637 rows=95,067 loops=1)

  • Sort Key: three_golf3kilo_oscar.india_zulu
  • Sort Method: quicksort Memory: 7,529kB
13. 732.739 1,556.248 ↓ 1.7 95,067 1

HashAggregate (cost=65,939.650..66,507.260 rows=56,761 width=8) (actual time=1,380.165..1,556.248 rows=95,067 loops=1)

  • Group Key: three_golf3kilo_oscar.india_zulu
14. 823.509 823.509 ↓ 1.3 261,713 1

Bitmap Heap Scan on foxtrot yankee (cost=5,837.820..65,424.100 rows=206,220 width=8) (actual time=164.795..823.509 rows=261,713 loops=1)

  • Recheck Cond: ((india_papa)::text = ANY ('kilo_yankee'::text[]))
  • Filter: ((seven)::text = ANY ('quebec_echo'::text[]))
  • Heap Blocks: exact=36,537
  • -> Bitmap Index Scan on cl_claim_provider_federal_tax_id (cost=0.00..5786.27 rows=264,013 width=0) (actual time=132.425..132.425 rows=261,737 loops=1
  • Index Cond: ((india_papa)::text = ANY ('kilo_yankee'::text[]))
Planning time : 12.126 ms
Execution time : 17,863.847 ms