explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pyyP

Settings
# exclusive inclusive rows x rows loops node
1. 1.940 375.894 ↓ 510.0 510 1

GroupAggregate (cost=40,662.35..40,662.36 rows=1 width=49) (actual time=373.390..375.894 rows=510 loops=1)

  • Group Key: t8._fld567rref
2. 2.029 373.954 ↓ 510.0 510 1

Sort (cost=40,662.35..40,662.35 rows=1 width=23) (actual time=373.365..373.954 rows=510 loops=1)

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

Hash Join (cost=39,956.71..40,662.32 rows=1 width=23) (actual time=369.191..371.925 rows=510 loops=1)

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

Index Scan using _document30_vt50_sk on _document30_vt50 t9 (cost=0.17..704.58 rows=795 width=20) (actual time=0.069..1.062 rows=510 loops=1)

  • Index Cond: (_document30_idrref = '\\xbeab00090ffe000111e8fd5604f5605b'::bytea)
5. 1.538 369.080 ↓ 510.0 510 1

Hash (cost=39,956.53..39,956.53 rows=1 width=40) (actual time=369.078..369.080 rows=510 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
6. 4.560 367.542 ↓ 510.0 510 1

Nested Loop (cost=39,895.52..39,956.53 rows=1 width=40) (actual time=344.243..367.542 rows=510 loops=1)

7. 8.765 353.292 ↓ 36.4 510 1

GroupAggregate (cost=39,895.30..39,896.89 rows=14 width=74) (actual time=344.169..353.292 rows=510 loops=1)

  • Group Key: (max(t4._period)), t4._fld567rref, t4._fld568rref
8. 2.985 344.527 ↓ 36.4 510 1

Sort (cost=39,895.30..39,895.31 rows=14 width=59) (actual time=343.452..344.527 rows=510 loops=1)

  • Sort Key: (max(t4._period)), t4._fld567rref, t4._fld568rref
  • Sort Method: quicksort Memory: 96kB
9. 4.188 341.542 ↓ 36.4 510 1

Nested Loop (cost=21,059.51..39,894.94 rows=14 width=59) (actual time=324.788..341.542 rows=510 loops=1)

10. 2.139 328.174 ↑ 12.5 510 1

Hash Join (cost=21,059.29..21,340.19 rows=6,351 width=62) (actual time=324.638..328.174 rows=510 loops=1)

  • Hash Cond: (t4._fld567rref = t7._fld52rref)
11. 87.504 322.508 ↑ 24.9 510 1

HashAggregate (cost=20,337.73..20,464.75 rows=12,702 width=42) (actual time=321.080..322.508 rows=510 loops=1)

  • Group Key: t4._fld567rref, t4._fld568rref
12. 115.863 235.004 ↑ 1.3 53,413 1

Nested Loop (cost=705.59..20,127.85 rows=69,958 width=42) (actual time=2.073..235.004 rows=53,413 loops=1)

13. 2.033 2.861 ↑ 1.5 510 1

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

  • Group Key: t5._fld52rref
14. 0.828 0.828 ↑ 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.027..0.828 rows=510 loops=1)

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

Index Scan using _inforg566_4 on _inforg566 t4 (cost=0.22..24.34 rows=84 width=42) (actual time=0.042..0.228 rows=105 loops=510)

  • Index Cond: ((_fld567rref = t5._fld52rref) AND (_active = true))
  • Filter: _active
16. 0.802 3.527 ↑ 1.5 510 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
17. 1.702 2.725 ↑ 1.5 510 1

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

  • Group Key: t7._fld52rref
18. 1.023 1.023 ↑ 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.027..1.023 rows=510 loops=1)

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

Index Scan using _inforg566_4 on _inforg566 t6 (cost=0.22..2.91 rows=1 width=59) (actual time=0.016..0.018 rows=1 loops=510)

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

Index Scan using _inforg566_4 on _inforg566 t8 (cost=0.22..4.24 rows=1 width=65) (actual time=0.017..0.019 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 : 6.251 ms
Execution time : 387.210 ms