explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dbEF

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 13,742.131 ↑ 6.0 1 1

Append (cost=0.00..583,520.82 rows=6 width=462) (actual time=11,965.824..13,742.131 rows=1 loops=1)

  • Buffers: shared hit=15,398 read=554,392
2. 0.004 13,742.114 ↑ 3.0 1 1

Append (cost=0.00..583,518.68 rows=3 width=458) (actual time=11,965.823..13,742.114 rows=1 loops=1)

  • Buffers: shared hit=15,396 read=554,392
3. 13,742.085 13,742.085 ↑ 1.0 1 1

Seq Scan on audit.audit_2019_09_1 (cost=0.00..583,514.38 rows=1 width=461) (actual time=11,965.822..13,742.085 rows=1 loops=1)

  • Output: audit_2019_09_1.id, audit_2019_09_1.event_date, audit_2019_09_1.event_type, audit_2019_09_1.object_id, audit_2019_09_1.user_id, audit_2019_09_1.username, audit_2019_09_1.source_workstation, audit_2019_09_1.context, audit_2019_09_1.creation_date, audit_2019_09_1.hostname, audit_2019_09_1.audit_type_id, audit_2019_09_1.sender_id, audit_2019_09_1.receiver_id, audit_2019_09_1.object_name_id, audit_2019_09_1.object_type_id, audit_2019_09_1.source_application_id, audit_2019_09_1.object_type, audit_2019_09_1.object_name, audit_2019_09_1.source_application
  • Filter: (audit_2019_09_1.id = '812910e0-f60e-ad63-4d6f-bd3550fbb724'::uuid)
  • Rows Removed by Filter: 1,120,998
  • Buffers: shared hit=15,392 read=554,392
4. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on audit.audit_2019_09_2 (cost=0.00..1.04 rows=1 width=466) (actual time=0.015..0.015 rows=0 loops=1)

  • Output: audit_2019_09_2.id, audit_2019_09_2.event_date, audit_2019_09_2.event_type, audit_2019_09_2.object_id, audit_2019_09_2.user_id, audit_2019_09_2.username, audit_2019_09_2.source_workstation, audit_2019_09_2.context, audit_2019_09_2.creation_date, audit_2019_09_2.hostname, audit_2019_09_2.audit_type_id, audit_2019_09_2.sender_id, audit_2019_09_2.receiver_id, audit_2019_09_2.object_name_id, audit_2019_09_2.object_type_id, audit_2019_09_2.source_application_id, audit_2019_09_2.object_type, audit_2019_09_2.object_name, audit_2019_09_2.source_application
  • Filter: (audit_2019_09_2.id = '812910e0-f60e-ad63-4d6f-bd3550fbb724'::uuid)
  • Rows Removed by Filter: 3
  • Buffers: shared hit=1
5. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on audit.audit_2019_09_3 (cost=0.00..3.25 rows=1 width=448) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: audit_2019_09_3.id, audit_2019_09_3.event_date, audit_2019_09_3.event_type, audit_2019_09_3.object_id, audit_2019_09_3.user_id, audit_2019_09_3.username, audit_2019_09_3.source_workstation, audit_2019_09_3.context, audit_2019_09_3.creation_date, audit_2019_09_3.hostname, audit_2019_09_3.audit_type_id, audit_2019_09_3.sender_id, audit_2019_09_3.receiver_id, audit_2019_09_3.object_name_id, audit_2019_09_3.object_type_id, audit_2019_09_3.source_application_id, audit_2019_09_3.object_type, audit_2019_09_3.object_name, audit_2019_09_3.source_application
  • Filter: (audit_2019_09_3.id = '812910e0-f60e-ad63-4d6f-bd3550fbb724'::uuid)
  • Rows Removed by Filter: 20
  • Buffers: shared hit=3
6. 0.001 0.012 ↓ 0.0 0 1

Append (cost=0.00..2.11 rows=2 width=466) (actual time=0.012..0.012 rows=0 loops=1)

  • Buffers: shared hit=2
7. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on audit.audit_2019_10_1 (cost=0.00..1.09 rows=1 width=466) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: audit_2019_10_1.id, audit_2019_10_1.event_date, audit_2019_10_1.event_type, audit_2019_10_1.object_id, audit_2019_10_1.user_id, audit_2019_10_1.username, audit_2019_10_1.source_workstation, audit_2019_10_1.context, audit_2019_10_1.creation_date, audit_2019_10_1.hostname, audit_2019_10_1.audit_type_id, audit_2019_10_1.sender_id, audit_2019_10_1.receiver_id, audit_2019_10_1.object_name_id, audit_2019_10_1.object_type_id, audit_2019_10_1.source_application_id, audit_2019_10_1.object_type, audit_2019_10_1.object_name, audit_2019_10_1.source_application
  • Filter: (audit_2019_10_1.id = '812910e0-f60e-ad63-4d6f-bd3550fbb724'::uuid)
  • Rows Removed by Filter: 7
  • Buffers: shared hit=1
8. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on audit.audit_2019_10_2 (cost=0.00..1.01 rows=1 width=466) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: audit_2019_10_2.id, audit_2019_10_2.event_date, audit_2019_10_2.event_type, audit_2019_10_2.object_id, audit_2019_10_2.user_id, audit_2019_10_2.username, audit_2019_10_2.source_workstation, audit_2019_10_2.context, audit_2019_10_2.creation_date, audit_2019_10_2.hostname, audit_2019_10_2.audit_type_id, audit_2019_10_2.sender_id, audit_2019_10_2.receiver_id, audit_2019_10_2.object_name_id, audit_2019_10_2.object_type_id, audit_2019_10_2.source_application_id, audit_2019_10_2.object_type, audit_2019_10_2.object_name, audit_2019_10_2.source_application
  • Filter: (audit_2019_10_2.id = '812910e0-f60e-ad63-4d6f-bd3550fbb724'::uuid)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1
9. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on audit.audit_2019_11 (cost=0.00..0.00 rows=1 width=466) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: audit_2019_11.id, audit_2019_11.event_date, audit_2019_11.event_type, audit_2019_11.object_id, audit_2019_11.user_id, audit_2019_11.username, audit_2019_11.source_workstation, audit_2019_11.context, audit_2019_11.creation_date, audit_2019_11.hostname, audit_2019_11.audit_type_id, audit_2019_11.sender_id, audit_2019_11.receiver_id, audit_2019_11.object_name_id, audit_2019_11.object_type_id, audit_2019_11.source_application_id, audit_2019_11.object_type, audit_2019_11.object_name, audit_2019_11.source_application
  • Filter: (audit_2019_11.id = '812910e0-f60e-ad63-4d6f-bd3550fbb724'::uuid)
Planning time : 0.566 ms
Execution time : 13,742.176 ms