explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ZPX

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 4.958 1,952.349 ↑ 2.3 67 1

HashAggregate (cost=251,315.390..251,316.960 rows=157 width=4) (actual time=1,952.282..1,952.349 rows=67 loops=1)

2. 13.517 1,947.391 ↑ 29.4 3,322 1

Nested Loop (cost=1,678.360..250,826.310 rows=97,817 width=4) (actual time=39.496..1,947.391 rows=3,322 loops=1)

3. 878.785 1,910.394 ↑ 32.1 2,935 1

Hash Left Join (cost=1,678.360..75,649.710 rows=94,105 width=8) (actual time=39.477..1,910.394 rows=2,935 loops=1)

  • Hash Cond: ((two_india.sierra)::text = (uniform.sierra)::text)
  • Filter: ((two_india.two_juliet @ 'juliet_two'::seven_five) OR ((uniform.tango && 'juliet_two'::seven_five) AND november_papa(uniform.tango, 'juliet_two'::seven_five)))
4. 992.652 992.652 ↓ 1.0 801,934 1

Index Scan using india_five on two_india (cost=0.000..36,121.240 rows=799,554 width=125) (actual time=0.019..992.652 rows=801,934 loops=1)

  • Index Cond: ((seven_papa > 'two_foxtrot'::timestamp with time zone) AND (seven_papa < 'india_two'::timestamp with time zone))
5. 21.998 38.957 ↓ 1.0 15,848 1

Hash (cost=521.380..521.380 rows=15,838 width=469) (actual time=38.957..38.957 rows=15,848 loops=1)

  • Buckets: 1024 Batches: 8 Memory Usage: 322kB
6. 16.959 16.959 ↓ 1.0 15,848 1

Seq Scan on uniform (cost=0.000..521.380 rows=15,838 width=469) (actual time=0.007..16.959 rows=15,848 loops=1)

7. 23.480 23.480 ↑ 1.0 1 2,935

Index Scan using xray on juliet_quebec (cost=0.000..1.850 rows=1 width=12) (actual time=0.007..0.008 rows=1 loops=2,935)

  • Index Cond: (november_whiskey = two_india.november_whiskey)