explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4fB6

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 810,031.590 ↓ 0.0 0 1

Limit (cost=1.000..2,226,238.950 rows=1 width=4) (actual time=810,031.590..810,031.590 rows=0 loops=1)

  • Output: 1
  • Buffers: shared hit=50707924 read=5596404 written=39006
  • I/O Timings: read=635758.061 write=866.264
2. 35,025.072 810,031.588 ↓ 0.0 0 1

Merge Left Join (cost=1.000..8,904,952.800 rows=4 width=4) (actual time=810,031.588..810,031.588 rows=0 loops=1)

  • Output: 1
  • Merge Cond: (six.quebec_seven = two_four.golf_charlie)
  • Filter: (((six.mike_four)::text = 'echo_bravo'::text) OR ((two_four.alpha_bravo)::text = 'echo_bravo'::text))
  • Rows Removed by Filter: 57653864
  • Buffers: shared hit=50707924 read=5596404 written=39006
  • I/O Timings: read=635758.061 write=866.264
3. 112,930.254 112,930.254 ↓ 1.0 57,507,578 1

Index Scan using uniform_xray on yankee (cost=0.560..2,679,531.240 rows=56,655,024 width=14) (actual time=0.045..112,930.254 rows=57,507,578 loops=1)

  • Output: six.quebec_seven, six.echo_hotel, six.charlie_oscar, six.uniform_six, six.alpha_victor, six.mike_four, six.tango, six.four, six.golf_golf, six.oscar_charlie, six.oscar_papa, six.hotel_victor, six.victor_seven, six.hotel_juliet, six.xray, six.charlie_victor_echo, six.victor_victor, six.hotel_charlie, six.bravo_mike_uniform, six.golf_delta, six.quebec_foxtrot, six.bravo_mike_november
  • Buffers: shared hit=37604996 read=703462 written=3849
  • I/O Timings: read=39557.847 write=87.642
4. 662,076.262 662,076.262 ↓ 1.0 25,291,331 1

Index Scan using zulu on kilo_oscar (cost=0.440..5,647,124.160 rows=25,272,006 width=18) (actual time=0.009..662,076.262 rows=25,291,331 loops=1)

  • Output: two_four.quebec_seven, two_four.echo_hotel, two_four.charlie_oscar, two_four.golf_charlie, two_four.alpha_victor, two_four.lima_golf, two_four.lima_whiskey, two_four.romeo, two_four.sierra, two_four.three, two_four.kilo_india, two_four.uniform_oscar, two_four.alpha_bravo, two_four.mike_quebec, two_four.alpha_yankee, two_four.hotel_india, two_four.two_hotel, two_four.charlie_golf, two_four.juliet, two_four.charlie_victor_golf, two_four.india, two_four.lima_victor
  • Buffers: shared hit=13102928 read=4892942 written=35157
  • I/O Timings: read=596200.214 write=778.622
Planning time : 0.833 ms
Execution time : 810,031.909 ms