explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PIg1

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.482 ↑ 2,000,000.0 1 1

Append (cost=4.00..100,465.61 rows=2,000,000 width=128) (actual time=0.439..0.482 rows=1 loops=1)

2.          

CTE get_event

3. 0.001 0.164 ↑ 1.0 1 1

Append (cost=0.55..3.58 rows=1 width=732) (actual time=0.163..0.164 rows=1 loops=1)

4. 0.163 0.163 ↑ 1.0 1 1

Index Scan using events_org_part_default_evn_seq_vrange_uidx on events_org_part_default e_2 (cost=0.55..3.58 rows=1 width=732) (actual time=0.162..0.163 rows=1 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = '851e862e-2e34-48c3-b2f1-98b281aeae32'::uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> '2019-12-10 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 4
5. 0.009 0.476 ↑ 1,000,000.0 1 1

Nested Loop Left Join (cost=0.42..35,232.74 rows=1,000,000 width=128) (actual time=0.438..0.476 rows=1 loops=1)

6. 0.003 0.443 ↑ 100.0 1 1

Nested Loop (cost=0.42..5.99 rows=100 width=1,023) (actual time=0.405..0.443 rows=1 loops=1)

7. 0.014 0.369 ↑ 1.0 1 1

Nested Loop (cost=0.42..3.47 rows=1 width=991) (actual time=0.332..0.369 rows=1 loops=1)

8. 0.169 0.169 ↑ 1.0 1 1

CTE Scan on get_event e (cost=0.00..0.02 rows=1 width=24) (actual time=0.167..0.169 rows=1 loops=1)

  • Filter: (choices IS NULL)
9. 0.186 0.186 ↑ 1.0 1 1

Index Scan using forms_org_seq_vrange_uidx on forms f (cost=0.42..3.44 rows=1 width=1,026) (actual time=0.152..0.186 rows=1 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (form_uuid = e.form_uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> e.created))
  • Rows Removed by Filter: 11
10. 0.070 0.071 ↑ 100.0 1 1

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.070..0.071 rows=1 loops=1)

11. 0.001 0.001 ↑ 1.0 1 1

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

12. 0.008 0.024 ↓ 0.0 0 1

ProjectSet (cost=0.00..52.27 rows=10,000 width=32) (actual time=0.024..0.024 rows=0 loops=1)

13. 0.016 0.016 ↑ 100.0 1 1

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.015..0.016 rows=1 loops=1)

14. 0.000 0.000 ↑ 1.0 1 1

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

15. 0.001 0.003 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..35,229.29 rows=1,000,000 width=128) (actual time=0.003..0.003 rows=0 loops=1)

16. 0.000 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.00..2.54 rows=100 width=64) (actual time=0.002..0.002 rows=0 loops=1)

17. 0.002 0.002 ↓ 0.0 0 1

CTE Scan on get_event e_1 (cost=0.00..0.02 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (choices IS NOT NULL)
  • Rows Removed by Filter: 1
18. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

20. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.00..52.27 rows=10,000 width=32) (never executed)

21. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

Planning time : 5,910.385 ms
Execution time : 1.359 ms