explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CECF

Settings
# exclusive inclusive rows x rows loops node
1. 1.003 245.864 ↓ 510.0 510 1

GroupAggregate (cost=39,839.92..39,839.94 rows=1 width=49) (actual time=244.483..245.864 rows=510 loops=1)

  • Group Key: t8._fld567rref
2. 1.262 244.861 ↓ 510.0 510 1

Sort (cost=39,839.92..39,839.93 rows=1 width=23) (actual time=244.474..244.861 rows=510 loops=1)

  • Sort Key: t8._fld567rref
  • Sort Method: quicksort Memory: 64kB
3. 1.830 243.599 ↓ 510.0 510 1

Nested Loop (cost=39,778.88..39,839.90 rows=1 width=23) (actual time=234.928..243.599 rows=510 loops=1)

4. 3.090 238.199 ↓ 36.4 510 1

GroupAggregate (cost=39,778.66..39,780.26 rows=14 width=74) (actual time=234.907..238.199 rows=510 loops=1)

  • Group Key: (max(t4._period)), t4._fld567rref, t4._fld568rref
5. 1.402 235.109 ↓ 36.4 510 1

Sort (cost=39,778.66..39,778.68 rows=14 width=59) (actual time=234.617..235.109 rows=510 loops=1)

  • Sort Key: (max(t4._period)), t4._fld567rref, t4._fld568rref
  • Sort Method: quicksort Memory: 96kB
6. 1.714 233.707 ↓ 36.4 510 1

Nested Loop (cost=21,080.04..39,778.31 rows=14 width=59) (actual time=226.202..233.707 rows=510 loops=1)

7. 1.093 227.913 ↑ 12.3 510 1

Hash Join (cost=21,079.82..21,357.81 rows=6,286 width=62) (actual time=226.173..227.913 rows=510 loops=1)

  • Hash Cond: (t4._fld567rref = t7._fld52rref)
8. 61.096 224.655 ↑ 24.7 510 1

HashAggregate (cost=20,358.26..20,483.98 rows=12,572 width=42) (actual time=223.989..224.655 rows=510 loops=1)

  • Group Key: t4._fld567rref, t4._fld568rref
9. 86.853 163.559 ↑ 1.3 53,413 1

Nested Loop (cost=705.59..20,148.67 rows=69,863 width=42) (actual time=1.182..163.559 rows=53,413 loops=1)

10. 1.204 1.736 ↑ 1.5 510 1

HashAggregate (cost=705.37..713.08 rows=771 width=20) (actual time=1.092..1.736 rows=510 loops=1)

  • Group Key: t5._fld52rref
11. 0.532 0.532 ↑ 1.6 510 1

Index Scan using _document30_vt50_sk on _document30_vt50 t5 (cost=0.17..704.58 rows=795 width=20) (actual time=0.013..0.532 rows=510 loops=1)

  • Index Cond: (_document30_idrref = '\\xbeab00090ffe000111e8fd5604f5605b'::bytea)
12. 74.970 74.970 ↓ 1.2 105 510

Index Scan using _inforg566_4 on _inforg566 t4 (cost=0.22..24.36 rows=85 width=42) (actual time=0.024..0.147 rows=105 loops=510)

  • Index Cond: ((_fld567rref = t5._fld52rref) AND (_active = true))
  • Filter: _active
13. 0.496 2.165 ↑ 1.5 510 1

Hash (cost=713.08..713.08 rows=771 width=20) (actual time=2.165..2.165 rows=510 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
14. 1.012 1.669 ↑ 1.5 510 1

HashAggregate (cost=705.37..713.08 rows=771 width=20) (actual time=1.217..1.669 rows=510 loops=1)

  • Group Key: t7._fld52rref
15. 0.657 0.657 ↑ 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.030..0.657 rows=510 loops=1)

  • Index Cond: (_document30_idrref = '\\xbeab00090ffe000111e8fd5604f5605b'::bytea)
16. 4.080 4.080 ↑ 1.0 1 510

Index Scan using _inforg566_4 on _inforg566 t6 (cost=0.22..2.92 rows=1 width=59) (actual time=0.007..0.008 rows=1 loops=510)

  • Index Cond: ((_fld567rref = t4._fld567rref) AND (_period = (max(t4._period))) AND (_active = true))
  • Filter: (_active AND (t4._fld568rref = _fld568rref))
17. 3.570 3.570 ↑ 1.0 1 510

Index Scan using _inforg566_4 on _inforg566 t8 (cost=0.22..4.24 rows=1 width=65) (actual time=0.006..0.007 rows=1 loops=510)

  • Index Cond: ((_fld567rref = t4._fld567rref) AND (_period = (max(t4._period))) AND (_recorderrref = (max(t6._recorderrref))))
  • Filter: (t4._fld568rref = _fld568rref)
Planning time : 3.440 ms
Execution time : 248.191 ms