explain.depesz.com

PostgreSQL's explain analyze made readable

Result: maZL

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 6.929 ↑ 1.0 1 1

Sort (cost=3,953.45..3,953.45 rows=1 width=64) (actual time=6.929..6.929 rows=1 loops=1)

  • Sort Key: (((1))::character varying)
  • Sort Method: quicksort Memory: 25kB
2. 0.004 6.924 ↑ 1.0 1 1

Nested Loop Left Join (cost=3,953.36..3,953.44 rows=1 width=64) (actual time=6.924..6.924 rows=1 loops=1)

  • Join Filter: (t.klass_id = ((1))::numeric)
3. 0.001 0.001 ↑ 1.0 1 1

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

4. 0.001 6.919 ↓ 0.0 0 1

GroupAggregate (cost=3,953.36..3,953.39 rows=1 width=40) (actual time=6.919..6.919 rows=0 loops=1)

  • Group Key: t.klass_id
5. 0.000 6.918 ↓ 0.0 0 1

Sort (cost=3,953.36..3,953.37 rows=1 width=14) (actual time=6.918..6.918 rows=0 loops=1)

  • Sort Key: t.klass_id
  • Sort Method: quicksort Memory: 25kB
6. 6.911 8.861 ↓ 0.0 0 1

Gather (cost=1,001.96..3,953.35 rows=1 width=14) (actual time=6.915..8.861 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 0.000 1.950 ↓ 0.0 0 3 / 3

Nested Loop (cost=1.96..2,953.25 rows=1 width=14) (actual time=1.950..1.950 rows=0 loops=3)

8. 0.000 1.950 ↓ 0.0 0 3 / 3

Nested Loop (cost=1.40..2,947.57 rows=2 width=27) (actual time=1.950..1.950 rows=0 loops=3)

9. 0.001 1.950 ↓ 0.0 0 3 / 3

Parallel Append (cost=0.70..2,135.44 rows=276 width=26) (actual time=1.950..1.950 rows=0 loops=3)

10. 1.949 1.949 ↓ 0.0 0 2 / 3

Parallel Index Only Scan using txdetails_p9_covered on txdetails_p9 t (cost=0.70..2,134.06 rows=276 width=26) (actual time=2.923..2.923 rows=0 loops=2)

  • Index Cond: ((company_id = '155935959'::numeric) AND (is_no_post IS NULL) AND (klass_id = ANY ('{1,12}'::numeric[])))
  • Heap Fetches: 0
11. 0.000 0.000 ↓ 0.0 0 / 3

Append (cost=0.70..2.93 rows=1 width=29) (never executed)

12. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using cashbasis_p9_pkey on cashbasis_p9 c (cost=0.70..2.93 rows=1 width=29) (never executed)

  • Index Cond: ((company_id = '155935959'::numeric) AND (tx_id = t.tx_id) AND (sequence = t.sequence))
  • Filter: ((cash_date >= '2019-01-01 00:00:00'::timestamp without time zone) AND (cash_date <= '2019-12-31 00:00:00'::timestamp without time zone))
13. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using accounts_pk on accounts a (cost=0.56..2.77 rows=1 width=13) (never executed)

  • Index Cond: ((company_id = '155935959'::numeric) AND (account_id = c.account_id))
  • Filter: (account_type_id = '10'::numeric)
Planning time : 20.510 ms
Execution time : 8.954 ms