explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0vlR

Settings
# exclusive inclusive rows x rows loops node
1. 1.731 6,431.954 ↓ 510.0 510 1

GroupAggregate (cost=62,069.59..62,069.60 rows=1 width=49) (actual time=6,429.608..6,431.954 rows=510 loops=1)

  • Group Key: t6._fld567rref
2. 1.608 6,430.223 ↓ 510.0 510 1

Sort (cost=62,069.59..62,069.59 rows=1 width=23) (actual time=6,429.592..6,430.223 rows=510 loops=1)

  • Sort Key: t6._fld567rref
  • Sort Method: quicksort Memory: 64kB
3. 1.614 6,428.615 ↓ 510.0 510 1

Hash Join (cost=61,363.95..62,069.56 rows=1 width=23) (actual time=6,426.149..6,428.615 rows=510 loops=1)

  • Hash Cond: (t7._fld52rref = t4._fld567rref)
4. 0.903 0.903 ↑ 1.6 510 1

Index Scan using _document30_vt50_sk on _document30_vt50 t7 (cost=0.17..704.58 rows=795 width=20) (actual time=0.031..0.903 rows=510 loops=1)

  • Index Cond: (_document30_idrref = '\\xbeab00090ffe000111e8fd5604f5605b'::bytea)
5. 39.611 6,426.098 ↓ 20,000.0 20,000 1

Hash (cost=61,363.77..61,363.77 rows=1 width=40) (actual time=6,426.097..6,426.098 rows=20,000 loops=1)

  • Buckets: 32768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1654kB
6. 106.953 6,386.487 ↓ 20,000.0 20,000 1

Nested Loop (cost=61,245.90..61,363.77 rows=1 width=40) (actual time=5,803.539..6,386.487 rows=20,000 loops=1)

7. 186.977 6,019.534 ↓ 740.7 20,000 1

GroupAggregate (cost=61,245.67..61,248.75 rows=27 width=74) (actual time=5,803.341..6,019.534 rows=20,000 loops=1)

  • Group Key: (max(t4._period)), t4._fld567rref, t4._fld568rref
8. 86.984 5,832.557 ↓ 740.7 20,000 1

Sort (cost=61,245.67..61,245.70 rows=27 width=59) (actual time=5,802.934..5,832.557 rows=20,000 loops=1)

  • Sort Key: (max(t4._period)), t4._fld567rref, t4._fld568rref
  • Sort Method: quicksort Memory: 3581kB
9. 1,540.696 5,745.573 ↓ 740.7 20,000 1

Hash Join (cost=30,751.69..61,244.94 rows=27 width=59) (actual time=2,927.244..5,745.573 rows=20,000 loops=1)

  • Hash Cond: ((t5._fld567rref = t4._fld567rref) AND (t5._fld568rref = t4._fld568rref) AND (t5._period = (max(t4._period))))
10. 1,277.776 1,277.776 ↑ 1.0 1,070,457 1

Seq Scan on _inforg566 t5 (cost=0.00..27,118.02 rows=1,071,502 width=59) (actual time=0.032..1,277.776 rows=1,070,457 loops=1)

  • Filter: _active
11. 24.742 2,927.101 ↓ 1.6 20,000 1

Hash (cost=30,586.57..30,586.57 rows=12,702 width=42) (actual time=2,927.100..2,927.101 rows=20,000 loops=1)

  • Buckets: 32768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 1819kB
12. 1,602.193 2,902.359 ↓ 1.6 20,000 1

HashAggregate (cost=30,332.53..30,459.55 rows=12,702 width=42) (actual time=2,878.719..2,902.359 rows=20,000 loops=1)

  • Group Key: t4._fld567rref, t4._fld568rref
13. 1,300.166 1,300.166 ↑ 1.0 1,070,457 1

Seq Scan on _inforg566 t4 (cost=0.00..27,118.02 rows=1,071,502 width=42) (actual time=0.009..1,300.166 rows=1,070,457 loops=1)

  • Filter: _active
14. 260.000 260.000 ↑ 1.0 1 20,000

Index Scan using _inforg566_4 on _inforg566 t6 (cost=0.22..4.24 rows=1 width=65) (actual time=0.011..0.013 rows=1 loops=20,000)

  • Index Cond: ((_fld567rref = t4._fld567rref) AND (_period = (max(t4._period))) AND (_recorderrref = (max(t5._recorderrref))))
  • Filter: (t4._fld568rref = _fld568rref)
Planning time : 2.478 ms
Execution time : 6,436.643 ms