explain.depesz.com

PostgreSQL's explain analyze made readable

Result: llVx

Settings
# exclusive inclusive rows x rows loops node
1. 0.476 3,826.432 ↑ 1.3 236 1

Sort (cost=246,820.93..246,821.71 rows=309 width=77) (actual time=3,826.417..3,826.432 rows=236 loops=1)

  • Sort Key: t1523_meetingactivitydim.c7386_activitydate DESC NULLS LAST, (CASE WHEN (t1523_meetingactivitydim.c7335_activitysubject IS NULL) THEN ''::text ELSE t1523_meetingactivitydim.c7335_activitysubject END)
  • Sort Method: quicksort Memory: 57kB
2.          

CTE activity_id_cte

3. 0.003 62.172 ↑ 1.0 20 1

Limit (cost=5,033.41..5,035.38 rows=20 width=16) (actual time=62.146..62.172 rows=20 loops=1)

4. 0.000 62.169 ↑ 149.8 20 1

Finalize GroupAggregate (cost=5,033.41..5,328.11 rows=2,996 width=16) (actual time=62.145..62.169 rows=20 loops=1)

  • Group Key: t1662_meetingactivityaccountfact.c7794_activitydate, t1662_meetingactivityaccountfact.c7801_activitychecksum
5. 29.681 62.244 ↑ 86.0 22 1

Gather Merge (cost=5,033.41..5,283.97 rows=1,891 width=16) (actual time=62.139..62.244 rows=22 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
6. 0.106 32.563 ↑ 7.0 270 2 / 2

Partial GroupAggregate (cost=4,033.40..4,071.22 rows=1,891 width=16) (actual time=32.440..32.563 rows=270 loops=2)

  • Group Key: t1662_meetingactivityaccountfact.c7794_activitydate, t1662_meetingactivityaccountfact.c7801_activitychecksum
7. 0.789 32.457 ↑ 6.0 316 2 / 2

Sort (cost=4,033.40..4,038.13 rows=1,891 width=16) (actual time=32.435..32.457 rows=316 loops=2)

  • Sort Key: t1662_meetingactivityaccountfact.c7794_activitydate DESC NULLS LAST, t1662_meetingactivityaccountfact.c7801_activitychecksum
  • Sort Method: quicksort Memory: 227kB
8. 31.668 31.668 ↑ 1.1 1,689 2 / 2

Parallel Seq Scan on t1662_meetingactivityaccountfact (cost=0.00..3,930.48 rows=1,891 width=16) (actual time=1.172..31.668 rows=1,689 loops=2)

  • Filter: ((NOT deleted) AND c7805_isshared AND (c7794_activitydate >= '1561532400000'::bigint) AND (c7794_activitydate < '1593241200000'::bigint) AND (end_stamp = '32503680000000'::bigint) AND (c7807_activityownersfuserid = 97))
  • Rows Removed by Filter: 58,901
9. 1.150 3,825.956 ↑ 1.3 236 1

Nested Loop (cost=1.50..241,772.78 rows=309 width=77) (actual time=79.003..3,825.956 rows=236 loops=1)

10. 1.101 3,744.566 ↑ 1.3 236 1

Nested Loop (cost=1.08..241,629.96 rows=309 width=24) (actual time=69.654..3,744.566 rows=236 loops=1)

11. 298.674 2,968.205 ↑ 1.4 236 1

Hash Semi Join (cost=0.65..241,433.70 rows=330 width=12) (actual time=62.710..2,968.205 rows=236 loops=1)

  • Hash Cond: (t1666_meetingactivityparticipantsfact.c7822_activityid = cte0.c1)
12. 2,607.339 2,607.339 ↑ 1.0 2,190,028 1

Seq Scan on t1666_meetingactivityparticipantsfact (cost=0.00..235,655.84 rows=2,199,444 width=8) (actual time=0.009..2,607.339 rows=2,190,028 loops=1)

  • Filter: ((NOT deleted) AND (end_stamp = '32503680000000'::bigint))
  • Rows Removed by Filter: 4,240,185
13. 0.009 62.192 ↑ 1.0 20 1

Hash (cost=0.40..0.40 rows=20 width=4) (actual time=62.192..62.192 rows=20 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
14. 62.183 62.183 ↑ 1.0 20 1

CTE Scan on activity_id_cte cte0 (cost=0.00..0.40 rows=20 width=4) (actual time=62.149..62.183 rows=20 loops=1)

15. 775.260 775.260 ↑ 1.0 1 236

Index Scan using t1527_meetingactivityparticipantsdim_sidendstampunique on t1527_meetingactivityparticipantsdim (cost=0.43..0.59 rows=1 width=20) (actual time=3.285..3.285 rows=1 loops=236)

  • Index Cond: ((sid = t1666_meetingactivityparticipantsfact.sid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: (NOT deleted)
16. 80.240 80.240 ↑ 1.0 1 236

Index Scan using t1523_meetingactivitydim_sidendstampunique on t1523_meetingactivitydim (cost=0.42..0.46 rows=1 width=40) (actual time=0.340..0.340 rows=1 loops=236)

  • Index Cond: ((sid = t1666_meetingactivityparticipantsfact.c7822_activityid) AND (end_stamp = '32503680000000'::bigint))
  • Filter: (NOT deleted)
Planning time : 4.087 ms
Execution time : 3,826.848 ms