explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pgrJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.071 ↓ 6.0 6 1

Sequence (cost=0.00..1,389,308,816,878.12 rows=1 width=20) (actual time=0.038..0.071 rows=6 loops=1)

  • (slice0) Executor memory: 329K bytes.
2. 0.003 0.013 ↓ 6.0 6 1

Shared Scan (share slice:id -1:0) (cost=0.00..0.00 rows=1 width=1) (actual time=0.012..0.013 rows=6 loops=1)

3. 0.007 0.010 ↓ 0.0 0 1

Materialize (cost=0.00..0.00 rows=1 width=1) (actual time=0.009..0.010 rows=0 loops=1)

4. 0.001 0.003 ↓ 6.0 6 1

Append (cost=0.00..0.00 rows=1 width=16) (actual time=0.001..0.003 rows=6 loops=1)

5. 0.000 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=1)

6. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1)

7. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.000 rows=1 loops=1)

8. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=1) (actual time=0.000..0.000 rows=1 loops=1)

9. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.000 rows=1 loops=1)

10. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=1) (actual time=0.000..0.000 rows=1 loops=1)

11. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=1)

12. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=1) (actual time=0.000..0.000 rows=1 loops=1)

13. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.000 rows=1 loops=1)

14. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=1) (actual time=0.000..0.000 rows=1 loops=1)

15. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.000 rows=1 loops=1)

16. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=1) (actual time=0.000..0.000 rows=1 loops=1)

17. 0.014 0.057 ↓ 6.0 6 1

Result (cost=0.00..1,389,308,816,878.12 rows=1 width=20) (actual time=0.024..0.057 rows=6 loops=1)

18. 0.001 0.001 ↓ 6.0 6 1

Shared Scan (share slice:id -1:0) (cost=0.00..431.00 rows=1 width=8) (actual time=0.001..0.001 rows=6 loops=1)

19.          

SubPlan (for Result)

20. 0.006 0.024 ↑ 1.0 1 6

Aggregate (cost=0.00..431.00 rows=1 width=4) (actual time=0.002..0.004 rows=1 loops=6)

21. 0.006 0.018 ↑ 1.0 1 6

Result (cost=0.00..431.00 rows=1 width=4) (actual time=0.001..0.003 rows=1 loops=6)

  • Filter: ((share0_ref5.party_id = share0_ref1.party_id) AND (share0_ref1.bs_start_date <= share0_ref5.bs_start_date))
22. 0.012 0.012 ↓ 2.0 2 6

Result (cost=0.00..431.00 rows=1 width=8) (actual time=0.001..0.002 rows=2 loops=6)

  • Filter: (share0_ref1.i_type = 'core'::text)
23. 0.000 0.000 ↓ 6.0 6 6

Shared Scan (share slice:id -1:0) (cost=0.00..431.00 rows=1 width=16) (actual time=0.000..0.000 rows=6 loops=6)

24. 0.000 0.012 ↑ 1.0 1 6

Aggregate (cost=0.00..431.21 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=6)

25. 0.006 0.012 ↓ 2.0 2 6

Result (cost=0.00..431.21 rows=1 width=4) (actual time=0.001..0.002 rows=2 loops=6)

  • Filter: ((share0_ref5.party_id = share0_ref2.party_id) AND (share0_ref2.bs_start_date <= share0_ref5.bs_start_date))
26. 0.006 0.006 ↓ 3.0 3 6

Result (cost=0.00..431.00 rows=1 width=8) (actual time=0.000..0.001 rows=3 loops=6)

  • Filter: (share0_ref2.i_type = 'p'::text)
27. 0.000 0.000 ↓ 6.0 6 6

Shared Scan (share slice:id -1:0) (cost=0.00..431.00 rows=1 width=16) (actual time=0.000..0.000 rows=6 loops=6)

28. 0.000 0.006 ↑ 1.0 1 6

Aggregate (cost=0.00..431.29 rows=1 width=4) (actual time=0.000..0.001 rows=1 loops=6)

29. 0.000 0.006 ↓ 0.0 0 6

Result (cost=0.00..431.29 rows=1 width=4) (actual time=0.000..0.001 rows=0 loops=6)

  • Filter: ((share0_ref5.party_id = share0_ref3.party_id) AND (share0_ref3.bs_start_date <= share0_ref5.bs_start_date))
30. 0.006 0.006 ↑ 1.0 1 6

Result (cost=0.00..431.00 rows=1 width=8) (actual time=0.000..0.001 rows=1 loops=6)

  • Filter: (share0_ref3.i_type = 'pm'::text)
31. 0.000 0.000 ↓ 6.0 6 6

Shared Scan (share slice:id -1:0) (cost=0.00..431.00 rows=1 width=16) (actual time=0.000..0.000 rows=6 loops=6)

Planning time : 79.659 ms
Execution time : 0.266 ms