explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CfWn

Settings
# exclusive inclusive rows x rows loops node
1. 9.441 1,226.711 ↑ 1.0 1 1

Aggregate (cost=77,243.660..77,243.670 rows=1 width=0) (actual time=1,226.711..1,226.711 rows=1 loops=1)

2. 40.124 1,217.270 ↓ 3.1 23,413 1

HashAggregate (cost=77,075.850..77,150.430 rows=7,458 width=21) (actual time=1,204.173..1,217.270 rows=23,413 loops=1)

  • Group Key: bravo_kilo.oscar_echo, bravo_kilo.mike
3. 35.593 1,177.146 ↓ 3.4 25,679 1

Nested Loop Semi Join (cost=1.690..77,038.560 rows=7,458 width=21) (actual time=0.101..1,177.146 rows=25,679 loops=1)

4. 94.021 730.763 ↓ 3.3 27,386 1

Nested Loop Semi Join (cost=0.430..64,794.180 rows=8,238 width=53) (actual time=0.073..730.763 rows=27,386 loops=1)

5. 216.577 216.577 ↓ 1.1 84,033 1

Seq Scan on alpha_papa bravo_kilo (cost=0.000..24,890.680 rows=79,595 width=37) (actual time=0.014..216.577 rows=84,033 loops=1)

  • Filter: ((((mike)::text ~~ 'tango'::text) OR (((mike five_romeo NULL) OR ((mike)::text ~ 'echo_juliet'::text)) AND ((oscar_echo)::text ~~ 'tango'::text))) AND (((mike)::text !~~ 'alpha_whiskey'::text) OR ((mike five_romeo NULL) AND ((oscar_echo)::text !~~ 'alpha_whiskey'::text)) OR (((mike)::text !~ 'echo_juliet'::text) AND ((oscar_echo)::text !~ 'echo_juliet'::text))))
  • Rows Removed by Filter: 264625
6. 420.165 420.165 ↓ 0.0 0 84,033

Index Scan using seven_five on seven_lima whiskey_sierra_bravo (cost=0.430..5.840 rows=86 width=16) (actual time=0.005..0.005 rows=0 loops=84,033)

  • Index Cond: (papa = bravo_kilo.charlie_romeo)
  • Filter: ((five_echo <= 'sierra'::date) AND ((whiskey_zulu > 0) OR (zulu_yankee > 0) OR (foxtrot_kilo > 0) OR (bravo_two > 0)))
  • Rows Removed by Filter: 1
7. 34.214 410.790 ↑ 1.0 1 27,386

Nested Loop (cost=1.260..1.480 rows=1 width=16) (actual time=0.015..0.015 rows=1 loops=27,386)

8. 60.088 273.860 ↑ 1.0 1 27,386

Nested Loop (cost=0.840..1.010 rows=1 width=32) (actual time=0.010..0.010 rows=1 loops=27,386)

9. 109.544 109.544 ↑ 1.0 1 27,386

Index Scan using whiskey_sierra_papa on kilo_foxtrot quebec (cost=0.420..0.450 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=27,386)

  • Index Cond: (papa = whiskey_sierra_bravo.papa)
10. 104.228 104.228 ↑ 1.0 1 26,057

Index Scan using echo_foxtrot on charlie_foxtrot six (cost=0.420..0.550 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=26,057)

  • Index Cond: (charlie_romeo = quebec.kilo_papa)
  • Filter: ((foxtrot_three <= 'oscar_yankee'::timestamp without time zone) AND ((lima five_romeo NULL) OR (lima <= 'oscar_yankee'::timestamp without time zone)))
  • Rows Removed by Filter: 0
11. 102.716 102.716 ↑ 1.0 1 25,679

Index Only Scan using foxtrot_oscar on five_golf zulu_bravo (cost=0.420..0.460 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=25,679)

  • Index Cond: (charlie_romeo = six.golf)
  • Heap Fetches: 2504
Planning time : 1.512 ms
Execution time : 1,226.845 ms