explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UISC : boom

Settings
# exclusive inclusive rows x rows loops node
1. 32.281 4,366.373 ↑ 32.6 4,155 1

Sort (cost=3,383,245.720..3,383,583.860 rows=135,254 width=1,328) (actual time=4,362.745..4,366.373 rows=4,155 loops=1)

  • Sort Key: uniform_juliet.lima oscar_quebec foxtrot
  • Sort Method: external merge Disk: 4656kB
2. 32.489 4,334.092 ↑ 32.6 4,155 1

Hash Join (cost=1,514,293.240..3,215,457.490 rows=135,254 width=1,328) (actual time=1,998.686..4,334.092 rows=4,155 loops=1)

  • Hash Cond: (three.india = uniform_bravo.quebec_seven_victor)
3. 134.022 4,291.208 ↑ 50.8 8,038 1

Hash Join (cost=1,504,587.680..3,119,739.180 rows=408,322 width=782) (actual time=1,988.143..4,291.208 rows=8,038 loops=1)

  • Hash Cond: (uniform_juliet.xray_bravo = three.quebec_seven_victor)
4. 2,225.254 3,403.133 ↑ 48.5 8,438 1

Bitmap Heap Scan on uniform_juliet (cost=901,426.850..2,255,636.810 rows=408,986 width=619) (actual time=1,193.671..3,403.133 rows=8,438 loops=1)

  • Recheck Cond: (((victor)::text = 'juliet_six'::text) OR (xray_india > 'uniform_echo'::timestamp without time zone))
  • Rows Removed by Index Recheck: 1773638
  • Filter: (((six five NULL) OR (six < 'quebec_alpha'::timestamp without time zone)) AND ((((victor)::text = 'juliet_six'::text) AND ((xray_india > 'juliet_foxtrot'::timestamp without time zone) OR (lima five NULL))) OR (xray_india > 'uniform_echo'::timestamp without time zone)))
  • Rows Removed by Filter: 58078
  • Heap Blocks: exact=39896 lossy=477398
5. 0.002 1,177.879 ↓ 0.0 0 1

BitmapOr (cost=901,426.850..901,426.850 rows=525,366 width=0) (actual time=1,177.879..1,177.879 rows=0 loops=1)

6. 732.415 732.415 ↓ 4.7 1,514,419 1

Bitmap Index Scan on oscar_november (cost=0.000..453,135.180 rows=323,188 width=0) (actual time=732.415..732.415 rows=1,514,419 loops=1)

  • Index Cond: ((victor)::text = 'juliet_six'::text)
7. 445.462 445.462 ↓ 7.3 1,483,280 1

Bitmap Index Scan on quebec_seven_romeo (cost=0.000..448,087.180 rows=202,178 width=0) (actual time=445.462..445.462 rows=1,483,280 loops=1)

  • Index Cond: (xray_india > 'uniform_echo'::timestamp without time zone)
8. 52.308 754.053 ↑ 239.9 33,266 1

Hash (cost=316,363.210..316,363.210 rows=7,980,450 width=163) (actual time=754.053..754.053 rows=33,266 loops=1)

  • Buckets: 32768 Batches: 512 Memory Usage: 293kB
9. 701.745 701.745 ↑ 239.9 33,266 1

Seq Scan on three (cost=0.000..316,363.210 rows=7,980,450 width=163) (actual time=0.123..701.745 rows=33,266 loops=1)

  • Filter: ((juliet_charlie)::text = ANY ('kilo'::text[]))
  • Rows Removed by Filter: 14
10. 0.837 10.395 ↑ 139.0 264 1

Hash (cost=6,665.840..6,665.840 rows=36,698 width=546) (actual time=10.395..10.395 rows=264 loops=1)

  • Buckets: 8192 Batches: 8 Memory Usage: 90kB
11. 9.558 9.558 ↑ 139.0 264 1

Seq Scan on uniform_bravo (cost=0.000..6,665.840 rows=36,698 width=546) (actual time=1.375..9.558 rows=264 loops=1)

  • Filter: (((sierra five NOT NULL) AND ((sierra)::text <> ''tango'2019-05-05 16:44:57.316063'::timestamp without time zone) OR (bravo five NULL) OR (juliet_sierra five FALSE))
  • Rows Removed by Filter: 483