explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wq1x

Settings
# exclusive inclusive rows x rows loops node
1. 53.364 314,930.147 ↑ 22.7 1,815 1

HashAggregate (cost=18,144,208.98..18,144,620.09 rows=41,111 width=24) (actual time=314,929.589..314,930.147 rows=1,815 loops=1)

2. 53,947.044 314,876.783 ↓ 2.1 88,191 1

Hash Join (cost=504.83..18,144,003.42 rows=41,111 width=24) (actual time=283,963.955..314,876.783 rows=88,191 loops=1)

  • Hash Cond: (z_t._document85_idrref = _document85._idrref)
3. 260,927.568 260,927.568 ↓ 1.0 408,762,210 1

Seq Scan on _document85_vt778 z_t (cost=0.00..16,101,560.99 rows=408,305,299 width=24) (actual time=0.004..260,927.568 rows=408,762,210 loops=1)

4. 0.359 2.171 ↓ 1.0 1,815 1

Hash (cost=483.03..483.03 rows=1,744 width=17) (actual time=2.171..2.171 rows=1,815 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 87kB
5. 1.812 1.812 ↓ 1.0 1,815 1

Index Only Scan using _document85_bydocdate on _document85 (cost=0.00..483.03 rows=1,744 width=17) (actual time=0.054..1.812 rows=1,815 loops=1)

  • Index Cond: ((_date_time > '2019-05-14 00:00:00'::timestamp without time zone) AND (_date_time < '2019-05-14 10:00:00'::timestamp without time zone))
  • Heap Fetches: 1815