explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KdIOY : After creating commit_id_contr_id_date_time_idx

Settings
# exclusive inclusive rows x rows loops node
1. 1.489 610.553 ↑ 1.0 1 1

Aggregate (cost=22,409.220..22,409.260 rows=1 width=24) (actual time=610.553..610.553 rows=1 loops=1)

2. 1.115 58.774 ↓ 8.8 830 1

Nested Loop Left Join (cost=3,663.180..6,028.230 rows=94 width=163) (actual time=13.383..58.774 rows=830 loops=1)

3. 0.967 56.829 ↓ 8.8 830 1

Nested Loop Left Join (cost=3,662.900..5,982.160 rows=94 width=159) (actual time=13.378..56.829 rows=830 loops=1)

4. 1.472 55.032 ↓ 8.8 830 1

Nested Loop (cost=3,662.610..5,674.730 rows=94 width=155) (actual time=13.365..55.032 rows=830 loops=1)

5. 26.030 51.900 ↓ 1.5 830 1

Hash Join (cost=3,662.320..5,483.110 rows=566 width=4) (actual time=13.342..51.900 rows=830 loops=1)

  • Hash Cond: (tango_charlie.tango_delta = india_alpha.quebec_seven)
6. 22.729 22.729 ↑ 1.0 98,876 1

Seq Scan on tango_charlie (cost=0.000..1,560.300 rows=99,230 width=8) (actual time=0.012..22.729 rows=98,876 loops=1)

7. 0.223 3.141 ↑ 1.1 701 1

Hash (cost=3,652.920..3,652.920 rows=752 width=4) (actual time=3.141..3.141 rows=701 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
8. 2.918 2.918 ↑ 1.1 701 1

Index Only Scan using seven on india_alpha (cost=0.420..3,652.920 rows=752 width=4) (actual time=1.661..2.918 rows=701 loops=1)

  • Index Cond: (quebec_foxtrot = 1040655273)
  • Heap Fetches: 231
9. 1.660 1.660 ↑ 1.0 1 830

Index Scan using mike_tango on charlie five_hotel (cost=0.290..0.340 rows=1 width=155) (actual time=0.002..0.002 rows=1 loops=830)

  • Index Cond: (quebec_seven = tango_charlie.foxtrot_yankee)
  • Filter: (india_four = 774527742)
10. 0.830 0.830 ↓ 0.0 0 830

Index Scan using mike_bravo on tango_november kilo_foxtrot (cost=0.290..3.270 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=830)

  • Index Cond: (quebec_seven = five_hotel.foxtrot_whiskey)
11. 0.830 0.830 ↑ 1.0 1 830

Index Scan using alpha_juliet on alpha_hotel juliet_xray (cost=0.280..0.490 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=830)

  • Index Cond: (quebec_seven = five_hotel.delta_india)
12.          

SubPlan (for Aggregate)

13. 206.827 550.290 ↓ 0.0 0 830

Nested Loop (cost=0.840..174.100 rows=1 width=0) (actual time=0.663..0.663 rows=0 loops=830)

14. 122.840 122.840 ↓ 19.0 266 830

Index Only Scan using delta_seven on tango_charlie lima (cost=0.420..52.660 rows=14 width=4) (actual time=0.005..0.148 rows=266 loops=830)

  • Index Cond: (foxtrot_yankee = five_hotel.quebec_seven)
  • Heap Fetches: 218104
15. 220.623 220.623 ↓ 0.0 0 220,623

Index Scan using seven on india_alpha quebec_sierra (cost=0.420..8.450 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=220,623)

  • Index Cond: ((quebec_seven = lima.tango_delta) AND (quebec_foxtrot = 1040655273) AND (five_echo("juliet_oscar") >= 'zulu_foxtrot'::date) AND (five_echo("juliet_oscar") <= 'bravo'::date))
16. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3,704.760..5,525.550 rows=3 width=4) (never executed)

  • Hash Cond: (mike_hotel1.tango_delta = golf1.quebec_seven)
17. 0.000 0.000 ↓ 0.0 0

Seq Scan on tango_charlie kilo_yankee (cost=0.000..1,560.300 rows=99,230 width=8) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Hash (cost=3,704.710..3,704.710 rows=4 width=4) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Index Scan using seven on india_alpha zulu_zulu (cost=0.420..3,704.710 rows=4 width=4) (never executed)

  • Index Cond: ((quebec_foxtrot = 1040655273) AND (five_echo("juliet_oscar") >= 'zulu_foxtrot'::date) AND (five_echo("juliet_oscar") <= 'bravo'::date))
Planning time : 1.491 ms
Execution time : 610.740 ms