explain.depesz.com

PostgreSQL's explain analyze made readable

Result: livA

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 102,085.227 ↓ 1.7 10 1

Limit (cost=2.71..4,885.65 rows=6 width=295) (actual time=0.305..102,085.227 rows=10 loops=1)

2. 0.058 102,085.223 ↑ 6.1 10 1

Nested Loop Left Join (cost=2.71..49,645.98 rows=61 width=295) (actual time=0.304..102,085.223 rows=10 loops=1)

3. 0.013 102,084.405 ↑ 6.1 10 1

Nested Loop (cost=2.43..48,304.43 rows=61 width=173) (actual time=0.106..102,084.405 rows=10 loops=1)

4. 0.011 102,084.342 ↑ 6.1 10 1

Nested Loop (cost=2.00..48,273.18 rows=61 width=177) (actual time=0.095..102,084.342 rows=10 loops=1)

5. 0.017 102,084.251 ↑ 6.1 10 1

Nested Loop (cost=1.57..48,245.51 rows=61 width=155) (actual time=0.082..102,084.251 rows=10 loops=1)

6. 0.012 102,084.124 ↑ 6.1 10 1

Nested Loop (cost=1.15..48,214.27 rows=61 width=163) (actual time=0.069..102,084.124 rows=10 loops=1)

7. 3.362 102,083.982 ↑ 6.2 10 1

Nested Loop (cost=0.71..48,009.50 rows=62 width=141) (actual time=0.053..102,083.982 rows=10 loops=1)

8. 914.652 914.652 ↑ 3.8 724 1

Index Scan Backward using ns_ntfn_id_idx on notifications_summary ns (cost=0.42..43,830.36 rows=2,744 width=85) (actual time=0.026..914.652 rows=724 loops=1)

  • Filter: ((min_when_created > $5) AND (min_when_created < $6) AND ((audit_type)::text <> 'DELINKED'::text))
  • Rows Removed by Filter: 601433
9. 101,165.968 101,165.968 ↓ 0.0 0 724

Index Scan using evs_pk on evs ev (cost=0.29..1.52 rows=1 width=64) (actual time=139.732..139.732 rows=0 loops=724)

  • Index Cond: (ev_id = ns.ev_id)
  • Filter: (company_id = $7)
  • Rows Removed by Filter: 1
10. 0.130 0.130 ↑ 1.0 1 10

Index Scan using dvc_pk on dvc (cost=0.43..3.30 rows=1 width=22) (actual time=0.013..0.013 rows=1 loops=10)

  • Index Cond: (dvc_id = ns.dvc_id)
11. 0.110 0.110 ↑ 1.0 1 10

Index Scan using recipients_pk on recipients dvc1 (cost=0.43..0.51 rows=1 width=16) (actual time=0.011..0.011 rows=1 loops=10)

  • Index Cond: (recipient_id = dvc.dvc_id)
12. 0.080 0.080 ↑ 1.0 1 10

Index Scan using persons_pk on persons person (cost=0.42..0.45 rows=1 width=22) (actual time=0.008..0.008 rows=1 loops=10)

  • Index Cond: (person_id = dvc.person_id)
13. 0.050 0.050 ↑ 1.0 1 10

Index Scan using recipients_pk on recipients person1 (cost=0.43..0.51 rows=1 width=20) (actual time=0.005..0.005 rows=1 loops=10)

  • Index Cond: (recipient_id = dvc.person_id)
14. 0.030 0.030 ↑ 1.0 1 10

Index Scan using org_dvc_names_pk on org_dvc_names orgdvcname (cost=0.28..0.30 rows=1 width=18) (actual time=0.003..0.003 rows=1 loops=10)

  • Index Cond: (dvc1.org_dvc_name_id = org_dvc_name_id)
15.          

SubPlan (for Nested Loop Left Join)

16. 0.010 0.430 ↑ 1.0 1 10

Aggregate (cost=9.11..9.12 rows=1 width=32) (actual time=0.043..0.043 rows=1 loops=10)

17. 0.070 0.420 ↓ 0.0 0 10

Nested Loop (cost=0.99..9.11 rows=1 width=25) (actual time=0.038..0.042 rows=0 loops=10)

18. 0.100 0.100 ↑ 1.0 1 10

Index Scan using audit_evs_all_pk on audit_evs_all ne (cost=0.43..3.45 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=10)

  • Index Cond: (audit_ev_id = ns.create_audit_ev_id)
19. 0.250 0.250 ↓ 0.0 0 10

Index Scan using idx_audit_evs_all_anpni on audit_evs_all ne1 (cost=0.56..5.64 rows=1 width=33) (actual time=0.021..0.025 rows=0 loops=10)

  • Index Cond: (((ap_audit_ev_type)::text = ANY ((ARRAY[$1, $2])::text[])) AND (ntfn_id = ne.root_ntfn_id))
20. 0.010 0.280 ↑ 1.0 1 10

Aggregate (cost=9.11..9.12 rows=1 width=32) (actual time=0.028..0.028 rows=1 loops=10)

21. 0.030 0.270 ↓ 0.0 0 10

Nested Loop (cost=0.99..9.11 rows=1 width=64) (actual time=0.024..0.027 rows=0 loops=10)

22. 0.030 0.030 ↑ 1.0 1 10

Index Scan using audit_evs_all_pk on audit_evs_all ne_1 (cost=0.43..3.45 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=10)

  • Index Cond: (audit_ev_id = ns.create_audit_ev_id)
23. 0.210 0.210 ↓ 0.0 0 10

Index Scan using idx_audit_evs_all_anpni on audit_evs_all ne1_1 (cost=0.56..5.64 rows=1 width=72) (actual time=0.018..0.021 rows=0 loops=10)

  • Index Cond: (((ap_audit_ev_type)::text = ANY ((ARRAY[$3, $4])::text[])) AND (ntfn_id = ne_1.root_ntfn_id))
24. 0.020 0.020 ↑ 1.0 1 10

Index Scan using audit_evs_all_pk on audit_evs_all ne_2 (cost=0.43..3.45 rows=1 width=64) (actual time=0.002..0.002 rows=1 loops=10)

  • Index Cond: (audit_ev_id = ns.create_audit_ev_id)